KERALA UNIVERSITY Class 4 database design Question Paper 2019

Practice authentic previous year questions for better exam preparation.

Sample Questions

What is a foreign key? Give an example.
(b) Create the following tables with foreign key constraints wherever necessary. DEPOSIT(actno,cname,bname,amount,adate) BRANCH(bname,city) CUSTOMERS(cname,City) BORROW(loanno,cname,bname,amount) Write the SQL query for the following
Differentiate two-tier and three-tier server architecture.
List out the various cases where use of null value would be appropriate.
Write any two data manipulation language commands with example.